USE [Accounting]
GO
/****** Object:  Table [dbo].[A_temp_sub_Journal]    Script Date: 03/08/2013 23:08:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_temp_sub_Journal](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ID_MM] [int] NULL,
	[Code_Co] [int] NULL,
	[id_Journal] [int] NULL,
	[date_Journal] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[code] [int] NULL,
	[AccName] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccLevel] [int] NULL,
	[AccSub] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Income_list] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Discription] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Code_cost] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Name_Cost] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Fiscal_year] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[states] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[madeen] [float] NULL,
	[daen] [float] NULL
) ON [PRIMARY]



*******************************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_temp_main_Journal]    Script Date: 03/08/2013 23:08:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_temp_main_Journal](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ID_MM] [int] NULL,
	[Code_Co] [int] NULL,
	[id_Journal] [bigint] NULL,
	[date_Journal] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[discription_Journal] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Fiscal_year] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[states] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]



*******************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_sub_Journal]    Script Date: 03/08/2013 23:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_sub_Journal](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ID_MM] [int] NULL,
	[Code_Co] [int] NULL,
	[id_Journal] [int] NULL,
	[date_Journal] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[code] [bigint] NULL,
	[AccName] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccLevel] [int] NULL,
	[AccSub] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Income_list] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Discription] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Code_cost] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Name_Cost] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Fiscal_year] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[states] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[madeen] [float] NULL,
	[daen] [float] NULL
) ON [PRIMARY]


******************************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_main_Journal]    Script Date: 03/08/2013 23:08:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_main_Journal](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ID_MM] [int] NULL,
	[Code_Co] [int] NULL,
	[id_Journal] [bigint] NULL,
	[date_Journal] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[discription_Journal] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Fiscal_year] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[states] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


****************************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_Fiscal_year]    Script Date: 03/08/2013 23:08:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_Fiscal_year](
	[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Code_Co] [int] NULL,
	[Name_Co] [nvarchar](max) COLLATE Arabic_CI_AS NULL,
	[Fiscal_year] [int] NULL
) ON [PRIMARY]


**************************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_Company_Code]    Script Date: 03/08/2013 23:07:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_Company_Code](
	[ID] [int] NULL,
	[ID_MM] [int] NULL,
	[Name_Co] [nvarchar](max) COLLATE Arabic_CI_AS NULL,
	[General_Manager] [nvarchar](max) COLLATE Arabic_CI_AS NULL,
	[Adress] [nvarchar](max) COLLATE Arabic_CI_AS NULL,
	[Accountant] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[Phone] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[Fax] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[P_Box] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[Postcode] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[start_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[End_Year] [nvarchar](50) COLLATE Arabic_CI_AS NULL,
	[Now_Year] [int] NULL,
	[State_Active] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


************************************************************

USE [Accounting]
GO
/****** Object:  Table [dbo].[A_ACCOUNT]    Script Date: 03/08/2013 23:06:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[A_ACCOUNT](
	[Code] [int] NOT NULL,
	[AccName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccFather] [bigint] NULL,
	[AccNemeFather] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[madeen_open] [float] NULL,
	[daen_open] [float] NULL,
	[Balance_open] [float] NULL,
	[AccDate] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Is_Main] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccSort] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[madeen] [float] NULL,
	[daen] [float] NULL,
	[Balance] [float] NULL,
	[AccSub] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccType] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AccLevel] [int] NULL,
	[Is_Cost] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Is_Frist_Store] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Is_Retained_Earnings] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Income_list] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Notes] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Code_Co] [int] NULL,
	[Name_Co] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Color_Level] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Is_Closed] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
